{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["ventas agencias"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"ventas agencias","index":0,"n_rows":18,"n_cols":13,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["VENTAS  PROVINCIA Y SUCURSALES",null,null,null,null,null,null,null,null,null,null,"Pontevedra","Lugo"]
[null,"Sucursales","xaneiro","febreiro","marzo","abril","maio","xuño","TOTAL ",null,null,"Cambados","Monforte"]
["Pontevedra","Cambados",82113,54205,90357,93511,19295,5419,{"$f":"SUM(C3:H3)","v":344900},null,null,"Illa de Arousa","Rábade"]
["Pontevedra","Illa de Arousa",65334,88071,52117,24666,16801,20431,{"$f":"SUM(C4:H4)","v":267420},null,null,"Ribadumia","Vilalba"]
["Lugo","Monforte",26910,24982,97437,54449,13519,4066,221363,null,null,"Sanxenxo","Viveiro"]
["Lugo","Rábade",89968,18133,7433,13978,29965,8934,168411,null,null,"Vilagarcia","Sarria"]
["Pontevedra","Ribadumia",25836,87927,71761,8412,5394,19437,218767]
["Pontevedra","Sanxenxo",23724,20356,26033,23453,16402,4270,114238]
["Pontevedra","Vilagarcia",29036,12708,12499,13240,24920,18478,110881]
["Lugo","Vilalba",25529,21231,22523,26292,10720,7794,114089]
["Lugo","Viveiro",23052,26011,26750,21522,28732,13856,139923]
["Lugo","Sarria",36000,30500,37000,36700,39000,42000,221200]
[null,"Totales",{"$f":"SUM(C3:C12)","v":427502},{"$f":"SUM(D3:D12)","v":384124},443910,316223,204748,144685,{"$f":"SUM(I3:I12)","v":1921192}]
[]
[null,null,null,"Ventas"]
["PROVINCIA","Pontevedra"]
["Sucursal","Sanxenxo",null,"Desref","Indirecto + Dirección","BuscarH",null,null,"Ventas Totales por provincia"]
["mes","febreiro",null,{"$f":"OFFSET($B$2,MATCH($B$17,$B$3:$B$12,0),MATCH($B$18,M_mes,0))","v":20356},{"$f":"INDIRECT(ADDRESS(MATCH($B$17,$B$1:$B$12,0),MATCH($B$18,$A$2:$L$2,0)))","v":20356},{"$f":"HLOOKUP($B$18,$B$2:$H$12,MATCH($B$17,B2:B12,0),0)","v":20356},null,null,{"$f":"SUM((SUMIFS(I3:I12,B3:B12,INDIRECT(B16))))","v":1056206}]